CREATE TABLE tblDataBufferStatus (
    UnixEpoch     BIGINT,
    DateTimeUTC   DATETIME,
    PosStatsNo    INTEGER,
    Time10sNo     INTEGER,
    Time1mNo      INTEGER,
    Time10mNo     INTEGER,
    Time1hNo      INTEGER,
    Time4hNo      INTEGER,
    Time1dNo      INTEGER,
    Time40dNo     INTEGER,
    ProcessVarsNo INTEGER,
    PosStatsPct   DOUBLE,
    Time10sPct    DOUBLE,
    Time1mPct     DOUBLE,
    Time10mPct    DOUBLE,
    Time1hPct     DOUBLE,
    Time4hPct     DOUBLE,
    Time1dPct     DOUBLE,
    Time40dPct    DOUBLE,
    ProcesVarsPct DOUBLE
);


CREATE TABLE tblStatusEvents (
    Id                 INTEGER  PRIMARY KEY AUTOINCREMENT,
    UTC_DateTime       DATETIME,
    UTC_DataTimeStamp  BIGINT,
    EventFlag          BOOLEAN,
    AutoMan            BOOLEAN,
    ActFullyOpen       BOOLEAN,
    ActFullyClosed     BOOLEAN,
    OverCurrentTrip    BOOLEAN,
    Discrepancy        BOOLEAN,
    ActuatorJammed     BOOLEAN,
    OverCurrentTripDly BOOLEAN,
    I_Enable           BOOLEAN,
    TrimOverRangeTrip  BOOLEAN,
    EastDoorOpen       BOOLEAN,
    WestDoorOpen       BOOLEAN,
    Spare1             BOOLEAN  DEFAULT (1),
    Spare2             BOOLEAN  DEFAULT (1),
    Spare3             BOOLEAN  DEFAULT (1),
    Spare4             BOOLEAN  DEFAULT (1),
    UTC_RecordAdded    DATETIME DEFAULT (CURRENT_TIMESTAMP) 
);
